version 10.0log using descriptive_data.log, replace#delimit ;*     ***************************************************************** *;*     ***************************************************************** *;*       File-Name:  descriptive_data.do                                 *;*       Date:       May 18, 2009                                        *;*       Author:     CRC and SNG                                         *;*       Purpose:    Get some descriptive statistics for EJPR paper.     *;*       Input File: comparison.dta (moved into Stata format from the    *;*                   "comparison" sheet in the data_replication.xls file)*;*       Output File:    descriptive_data.log                            *;*       Data Output:    descriptive_data.dta                            *;*       Previous file:  descriptive7.do                                 *;*       Machine:        Dell laptop                                     *;*     ****************************************************************  *;use descriptive_data.dta;set more off;summarize;*     ****************************************************************  *;*      Create summary information about average government duration     *;*       (This is data for Table 1, p. 127)                              *;*     ****************************************************************  *;*******************;*** all countries ***;*******************;sum  duration_cg;sum  duration_mrfh;sum  duration_cg if caretaker==0;sum  duration_mrfh if caretaker==0;*******************;*** Bulgaria ***;*******************;sum  duration_cg if countrycode==1;sum  duration_mrfh if countrycode==1;sum  duration_cg if countrycode==1 & caretaker==0;sum  duration_mrfh if countrycode==1 & caretaker==0;*******************;*** Croatia ***;*******************;sum  duration_cg if countrycode==2;sum  duration_mrfh if countrycode==2;************************;*** Czech Republic ***;************************;sum  duration_cg if countrycode==3;sum  duration_mrfh if countrycode==3;sum  duration_cg if countrycode==3 & caretaker==0;sum  duration_mrfh if countrycode==3 & caretaker==0;*******************;*** Estonia ***;*******************;sum  duration_cg if countrycode==4;sum  duration_mrfh if countrycode==4;sum  duration_cg if countrycode==4 & caretaker==0;sum  duration_mrfh if countrycode==4 & caretaker==0;*******************;*** Hungary ***;*******************;sum  duration_cg if countrycode==5;sum  duration_mrfh if countrycode==5;*******************;*** Latvia ***;*******************;sum  duration_cg if countrycode==6;sum  duration_mrfh if countrycode==6;*******************;*** Lithuania ***;*******************;sum  duration_cg if countrycode==7;sum  duration_mrfh if countrycode==7;sum  duration_cg if countrycode==7 & caretaker==0;sum  duration_mrfh if countrycode==7 & caretaker==0;*******************;*** Poland ***;*******************;sum  duration_cg if countrycode==8;sum  duration_mrfh if countrycode==8;*******************;*** Romania ***;*******************;sum  duration_cg if countrycode==9;sum  duration_mrfh if countrycode==9;sum  duration_cg if countrycode==9 & caretaker==0;sum  duration_mrfh if countrycode==9 & caretaker==0;*******************;*** Slovakia ***;*******************;sum  duration_cg if countrycode==10;sum  duration_mrfh if countrycode==10;*******************;*** Slovenia ***;*******************;sum  duration_cg if countrycode==11;sum  duration_mrfh if countrycode==11;*     ****************************************************************  *;*      Test whether mean durations are significantly different across   *;*      MRFH and CG measures (mentioned in the note following Table 1)   *;*     ****************************************************************  *;ttest duration_cg = duration_mrfh if caretaker==0;ttest duration_cg = duration_mrfh if countrycode==1;ttest duration_cg = duration_mrfh if countrycode==2;ttest duration_cg = duration_mrfh if countrycode==3;ttest duration_cg = duration_mrfh if countrycode==4;ttest duration_cg = duration_mrfh if countrycode==5;ttest duration_cg = duration_mrfh if countrycode==6;ttest duration_cg = duration_mrfh if countrycode==7;ttest duration_cg = duration_mrfh if countrycode==8;ttest duration_cg = duration_mrfh if countrycode==9;ttest duration_cg = duration_mrfh if countrycode==10;ttest duration_cg = duration_mrfh if countrycode==11;ttest duration_cg = duration_mrfh;ttest duration_cg = duration_mrfh if countrycode==1;ttest duration_cg = duration_mrfh if countrycode==3;ttest duration_cg = duration_mrfh if countrycode==4;ttest duration_cg = duration_mrfh if countrycode==7;ttest duration_cg = duration_mrfh if countrycode==9;*     ****************************************************************  *;*      Create summary information about average 'performance index'     *;*       (This is data for Table 2, p. 129)                              *;*     ****************************************************************  *;*** all countries ***;sum duration_percent;sum duration_percent if caretaker==0;*** Bulgaria ***;sum duration_percent if countrycode==1;sum duration_percent if countrycode==1 & caretaker==0;*** Croatia ***;sum duration_percent if countrycode== 2;*** Czech Republic ***;sum duration_percent if countrycode== 3;sum duration_percent if countrycode== 3 & caretaker==0;*** Estonia ***;sum duration_percent if countrycode== 4;sum duration_percent if countrycode== 4 & caretaker==0;*** Hungary ***;sum duration_percent if countrycode== 5;*** Latvia ***;sum duration_percent if countrycode== 6;*** Lithuania ***;sum duration_percent if countrycode== 7;sum duration_percent if countrycode== 7 & caretaker==0;*** Poland ***;sum duration_percent if countrycode== 8;*** Romania ***;sum duration_percent if countrycode== 9;sum duration_percent if countrycode== 9 & caretaker==0;*** Slovakia ***;sum duration_percent if countrycode== 10;*** Slovenia ***;sum duration_percent if countrycode==11;*     ****************************************************************  *;*     Create summary information about different types of governments   *;*       (This is data for Table 3, p. 131)                              *;*     ****************************************************************  *;gen majority=0;replace majority=1 if government==1;replace majority=1 if government==2;replace majority=1 if government==3;gen minority=0;replace minority=1 if government==4;replace minority=1 if government==5;***************************************************;*** single-party majority governments (type 1) ***;***************************************************;sum duration_cg if government==1;sum duration_mrfh if government==1;sum percent_difference if government==1;sum duration_percent if government==1;***************************************************;*** minimal-winning coalition governments (type 2) ***;***************************************************;sum duration_cg if government==2;sum duration_mrfh if government==2;sum percent_difference if government==2;sum duration_percent if government==2;***************************************************;*** surplus coalition governments (type 3) ***;***************************************************;sum duration_cg if government==3;sum duration_mrfh if government==3;sum percent_difference if government==3;sum duration_percent if government==3;***************************************************;*** single-party minority governments (type 4) ***;***************************************************;sum duration_cg if government==4;sum duration_mrfh if government==4;sum percent_difference if government==4;sum duration_percent if government==4;***************************************************;*** minority coalition governments (type 5) ***;***************************************************;sum duration_cg if government==5;sum duration_mrfh if government==5;sum percent_difference if government==5;sum duration_percent if government==5;***************************************************;***         all majority governments            ***;***************************************************;sum duration_cg if majority==1;sum duration_mrfh if majority==1;sum percent_difference if majority==1;sum duration_percent if majority==1;***************************************************;***         all minority governments            ***;***************************************************;sum duration_cg if minority==1;sum duration_mrfh if minority==1;sum percent_difference if minority==1;sum duration_percent if minority==1;log close;exit;